package com.ecoolex.ying.space.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class UserWorksShoppingExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public UserWorksShoppingExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public UserWorksShoppingExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public UserWorksShoppingExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        UserWorksShoppingExample example = new UserWorksShoppingExample();
        return example.createCriteria();
    }

    public UserWorksShoppingExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public UserWorksShoppingExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public UserWorksShoppingExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public UserWorksShoppingExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public UserWorksShoppingExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("userworksshopping.Id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("userworksshopping.Id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("userworksshopping.Id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Id = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("userworksshopping.Id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Id <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("userworksshopping.Id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Id > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("userworksshopping.Id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Id >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("userworksshopping.Id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Id < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("userworksshopping.Id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Id <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("userworksshopping.Id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("userworksshopping.Id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("userworksshopping.Id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("userworksshopping.Id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("userworksshopping.UserId is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("userworksshopping.UserId is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(Integer value) {
            addCriterion("userworksshopping.UserId =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.UserId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(Integer value) {
            addCriterion("userworksshopping.UserId <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.UserId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(Integer value) {
            addCriterion("userworksshopping.UserId >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.UserId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("userworksshopping.UserId >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.UserId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(Integer value) {
            addCriterion("userworksshopping.UserId <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.UserId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("userworksshopping.UserId <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.UserId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<Integer> values) {
            addCriterion("userworksshopping.UserId in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<Integer> values) {
            addCriterion("userworksshopping.UserId not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(Integer value1, Integer value2) {
            addCriterion("userworksshopping.UserId between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("userworksshopping.UserId not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andWorksIdIsNull() {
            addCriterion("userworksshopping.WorksId is null");
            return (Criteria) this;
        }

        public Criteria andWorksIdIsNotNull() {
            addCriterion("userworksshopping.WorksId is not null");
            return (Criteria) this;
        }

        public Criteria andWorksIdEqualTo(Integer value) {
            addCriterion("userworksshopping.WorksId =", value, "worksId");
            return (Criteria) this;
        }

        public Criteria andWorksIdEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.WorksId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andWorksIdNotEqualTo(Integer value) {
            addCriterion("userworksshopping.WorksId <>", value, "worksId");
            return (Criteria) this;
        }

        public Criteria andWorksIdNotEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.WorksId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andWorksIdGreaterThan(Integer value) {
            addCriterion("userworksshopping.WorksId >", value, "worksId");
            return (Criteria) this;
        }

        public Criteria andWorksIdGreaterThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.WorksId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andWorksIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("userworksshopping.WorksId >=", value, "worksId");
            return (Criteria) this;
        }

        public Criteria andWorksIdGreaterThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.WorksId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andWorksIdLessThan(Integer value) {
            addCriterion("userworksshopping.WorksId <", value, "worksId");
            return (Criteria) this;
        }

        public Criteria andWorksIdLessThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.WorksId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andWorksIdLessThanOrEqualTo(Integer value) {
            addCriterion("userworksshopping.WorksId <=", value, "worksId");
            return (Criteria) this;
        }

        public Criteria andWorksIdLessThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.WorksId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andWorksIdIn(List<Integer> values) {
            addCriterion("userworksshopping.WorksId in", values, "worksId");
            return (Criteria) this;
        }

        public Criteria andWorksIdNotIn(List<Integer> values) {
            addCriterion("userworksshopping.WorksId not in", values, "worksId");
            return (Criteria) this;
        }

        public Criteria andWorksIdBetween(Integer value1, Integer value2) {
            addCriterion("userworksshopping.WorksId between", value1, value2, "worksId");
            return (Criteria) this;
        }

        public Criteria andWorksIdNotBetween(Integer value1, Integer value2) {
            addCriterion("userworksshopping.WorksId not between", value1, value2, "worksId");
            return (Criteria) this;
        }

        public Criteria andStorageIdIsNull() {
            addCriterion("userworksshopping.StorageId is null");
            return (Criteria) this;
        }

        public Criteria andStorageIdIsNotNull() {
            addCriterion("userworksshopping.StorageId is not null");
            return (Criteria) this;
        }

        public Criteria andStorageIdEqualTo(String value) {
            addCriterion("userworksshopping.StorageId =", value, "storageId");
            return (Criteria) this;
        }

        public Criteria andStorageIdEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.StorageId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStorageIdNotEqualTo(String value) {
            addCriterion("userworksshopping.StorageId <>", value, "storageId");
            return (Criteria) this;
        }

        public Criteria andStorageIdNotEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.StorageId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStorageIdGreaterThan(String value) {
            addCriterion("userworksshopping.StorageId >", value, "storageId");
            return (Criteria) this;
        }

        public Criteria andStorageIdGreaterThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.StorageId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStorageIdGreaterThanOrEqualTo(String value) {
            addCriterion("userworksshopping.StorageId >=", value, "storageId");
            return (Criteria) this;
        }

        public Criteria andStorageIdGreaterThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.StorageId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStorageIdLessThan(String value) {
            addCriterion("userworksshopping.StorageId <", value, "storageId");
            return (Criteria) this;
        }

        public Criteria andStorageIdLessThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.StorageId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStorageIdLessThanOrEqualTo(String value) {
            addCriterion("userworksshopping.StorageId <=", value, "storageId");
            return (Criteria) this;
        }

        public Criteria andStorageIdLessThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.StorageId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStorageIdLike(String value) {
            addCriterion("userworksshopping.StorageId like", value, "storageId");
            return (Criteria) this;
        }

        public Criteria andStorageIdNotLike(String value) {
            addCriterion("userworksshopping.StorageId not like", value, "storageId");
            return (Criteria) this;
        }

        public Criteria andStorageIdIn(List<String> values) {
            addCriterion("userworksshopping.StorageId in", values, "storageId");
            return (Criteria) this;
        }

        public Criteria andStorageIdNotIn(List<String> values) {
            addCriterion("userworksshopping.StorageId not in", values, "storageId");
            return (Criteria) this;
        }

        public Criteria andStorageIdBetween(String value1, String value2) {
            addCriterion("userworksshopping.StorageId between", value1, value2, "storageId");
            return (Criteria) this;
        }

        public Criteria andStorageIdNotBetween(String value1, String value2) {
            addCriterion("userworksshopping.StorageId not between", value1, value2, "storageId");
            return (Criteria) this;
        }

        public Criteria andOrderedIsNull() {
            addCriterion("userworksshopping.Ordered is null");
            return (Criteria) this;
        }

        public Criteria andOrderedIsNotNull() {
            addCriterion("userworksshopping.Ordered is not null");
            return (Criteria) this;
        }

        public Criteria andOrderedEqualTo(Integer value) {
            addCriterion("userworksshopping.Ordered =", value, "ordered");
            return (Criteria) this;
        }

        public Criteria andOrderedEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Ordered = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderedNotEqualTo(Integer value) {
            addCriterion("userworksshopping.Ordered <>", value, "ordered");
            return (Criteria) this;
        }

        public Criteria andOrderedNotEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Ordered <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderedGreaterThan(Integer value) {
            addCriterion("userworksshopping.Ordered >", value, "ordered");
            return (Criteria) this;
        }

        public Criteria andOrderedGreaterThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Ordered > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderedGreaterThanOrEqualTo(Integer value) {
            addCriterion("userworksshopping.Ordered >=", value, "ordered");
            return (Criteria) this;
        }

        public Criteria andOrderedGreaterThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Ordered >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderedLessThan(Integer value) {
            addCriterion("userworksshopping.Ordered <", value, "ordered");
            return (Criteria) this;
        }

        public Criteria andOrderedLessThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Ordered < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderedLessThanOrEqualTo(Integer value) {
            addCriterion("userworksshopping.Ordered <=", value, "ordered");
            return (Criteria) this;
        }

        public Criteria andOrderedLessThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Ordered <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderedIn(List<Integer> values) {
            addCriterion("userworksshopping.Ordered in", values, "ordered");
            return (Criteria) this;
        }

        public Criteria andOrderedNotIn(List<Integer> values) {
            addCriterion("userworksshopping.Ordered not in", values, "ordered");
            return (Criteria) this;
        }

        public Criteria andOrderedBetween(Integer value1, Integer value2) {
            addCriterion("userworksshopping.Ordered between", value1, value2, "ordered");
            return (Criteria) this;
        }

        public Criteria andOrderedNotBetween(Integer value1, Integer value2) {
            addCriterion("userworksshopping.Ordered not between", value1, value2, "ordered");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("userworksshopping.`Type` is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("userworksshopping.`Type` is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("userworksshopping.`Type` =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.`Type` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Integer value) {
            addCriterion("userworksshopping.`Type` <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.`Type` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("userworksshopping.`Type` >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.`Type` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("userworksshopping.`Type` >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.`Type` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("userworksshopping.`Type` <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.`Type` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Integer value) {
            addCriterion("userworksshopping.`Type` <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.`Type` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Integer> values) {
            addCriterion("userworksshopping.`Type` in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Integer> values) {
            addCriterion("userworksshopping.`Type` not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Integer value1, Integer value2) {
            addCriterion("userworksshopping.`Type` between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("userworksshopping.`Type` not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andLabelIsNull() {
            addCriterion("userworksshopping.`Label` is null");
            return (Criteria) this;
        }

        public Criteria andLabelIsNotNull() {
            addCriterion("userworksshopping.`Label` is not null");
            return (Criteria) this;
        }

        public Criteria andLabelEqualTo(String value) {
            addCriterion("userworksshopping.`Label` =", value, "label");
            return (Criteria) this;
        }

        public Criteria andLabelEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.`Label` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLabelNotEqualTo(String value) {
            addCriterion("userworksshopping.`Label` <>", value, "label");
            return (Criteria) this;
        }

        public Criteria andLabelNotEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.`Label` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLabelGreaterThan(String value) {
            addCriterion("userworksshopping.`Label` >", value, "label");
            return (Criteria) this;
        }

        public Criteria andLabelGreaterThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.`Label` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLabelGreaterThanOrEqualTo(String value) {
            addCriterion("userworksshopping.`Label` >=", value, "label");
            return (Criteria) this;
        }

        public Criteria andLabelGreaterThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.`Label` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLabelLessThan(String value) {
            addCriterion("userworksshopping.`Label` <", value, "label");
            return (Criteria) this;
        }

        public Criteria andLabelLessThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.`Label` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLabelLessThanOrEqualTo(String value) {
            addCriterion("userworksshopping.`Label` <=", value, "label");
            return (Criteria) this;
        }

        public Criteria andLabelLessThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.`Label` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLabelLike(String value) {
            addCriterion("userworksshopping.`Label` like", value, "label");
            return (Criteria) this;
        }

        public Criteria andLabelNotLike(String value) {
            addCriterion("userworksshopping.`Label` not like", value, "label");
            return (Criteria) this;
        }

        public Criteria andLabelIn(List<String> values) {
            addCriterion("userworksshopping.`Label` in", values, "label");
            return (Criteria) this;
        }

        public Criteria andLabelNotIn(List<String> values) {
            addCriterion("userworksshopping.`Label` not in", values, "label");
            return (Criteria) this;
        }

        public Criteria andLabelBetween(String value1, String value2) {
            addCriterion("userworksshopping.`Label` between", value1, value2, "label");
            return (Criteria) this;
        }

        public Criteria andLabelNotBetween(String value1, String value2) {
            addCriterion("userworksshopping.`Label` not between", value1, value2, "label");
            return (Criteria) this;
        }

        public Criteria andLinkNameIsNull() {
            addCriterion("userworksshopping.LinkName is null");
            return (Criteria) this;
        }

        public Criteria andLinkNameIsNotNull() {
            addCriterion("userworksshopping.LinkName is not null");
            return (Criteria) this;
        }

        public Criteria andLinkNameEqualTo(String value) {
            addCriterion("userworksshopping.LinkName =", value, "linkName");
            return (Criteria) this;
        }

        public Criteria andLinkNameEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.LinkName = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLinkNameNotEqualTo(String value) {
            addCriterion("userworksshopping.LinkName <>", value, "linkName");
            return (Criteria) this;
        }

        public Criteria andLinkNameNotEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.LinkName <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLinkNameGreaterThan(String value) {
            addCriterion("userworksshopping.LinkName >", value, "linkName");
            return (Criteria) this;
        }

        public Criteria andLinkNameGreaterThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.LinkName > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLinkNameGreaterThanOrEqualTo(String value) {
            addCriterion("userworksshopping.LinkName >=", value, "linkName");
            return (Criteria) this;
        }

        public Criteria andLinkNameGreaterThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.LinkName >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLinkNameLessThan(String value) {
            addCriterion("userworksshopping.LinkName <", value, "linkName");
            return (Criteria) this;
        }

        public Criteria andLinkNameLessThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.LinkName < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLinkNameLessThanOrEqualTo(String value) {
            addCriterion("userworksshopping.LinkName <=", value, "linkName");
            return (Criteria) this;
        }

        public Criteria andLinkNameLessThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.LinkName <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLinkNameLike(String value) {
            addCriterion("userworksshopping.LinkName like", value, "linkName");
            return (Criteria) this;
        }

        public Criteria andLinkNameNotLike(String value) {
            addCriterion("userworksshopping.LinkName not like", value, "linkName");
            return (Criteria) this;
        }

        public Criteria andLinkNameIn(List<String> values) {
            addCriterion("userworksshopping.LinkName in", values, "linkName");
            return (Criteria) this;
        }

        public Criteria andLinkNameNotIn(List<String> values) {
            addCriterion("userworksshopping.LinkName not in", values, "linkName");
            return (Criteria) this;
        }

        public Criteria andLinkNameBetween(String value1, String value2) {
            addCriterion("userworksshopping.LinkName between", value1, value2, "linkName");
            return (Criteria) this;
        }

        public Criteria andLinkNameNotBetween(String value1, String value2) {
            addCriterion("userworksshopping.LinkName not between", value1, value2, "linkName");
            return (Criteria) this;
        }

        public Criteria andLinkIsNull() {
            addCriterion("userworksshopping.Link is null");
            return (Criteria) this;
        }

        public Criteria andLinkIsNotNull() {
            addCriterion("userworksshopping.Link is not null");
            return (Criteria) this;
        }

        public Criteria andLinkEqualTo(String value) {
            addCriterion("userworksshopping.Link =", value, "link");
            return (Criteria) this;
        }

        public Criteria andLinkEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Link = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLinkNotEqualTo(String value) {
            addCriterion("userworksshopping.Link <>", value, "link");
            return (Criteria) this;
        }

        public Criteria andLinkNotEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Link <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLinkGreaterThan(String value) {
            addCriterion("userworksshopping.Link >", value, "link");
            return (Criteria) this;
        }

        public Criteria andLinkGreaterThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Link > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLinkGreaterThanOrEqualTo(String value) {
            addCriterion("userworksshopping.Link >=", value, "link");
            return (Criteria) this;
        }

        public Criteria andLinkGreaterThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Link >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLinkLessThan(String value) {
            addCriterion("userworksshopping.Link <", value, "link");
            return (Criteria) this;
        }

        public Criteria andLinkLessThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Link < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLinkLessThanOrEqualTo(String value) {
            addCriterion("userworksshopping.Link <=", value, "link");
            return (Criteria) this;
        }

        public Criteria andLinkLessThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Link <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLinkLike(String value) {
            addCriterion("userworksshopping.Link like", value, "link");
            return (Criteria) this;
        }

        public Criteria andLinkNotLike(String value) {
            addCriterion("userworksshopping.Link not like", value, "link");
            return (Criteria) this;
        }

        public Criteria andLinkIn(List<String> values) {
            addCriterion("userworksshopping.Link in", values, "link");
            return (Criteria) this;
        }

        public Criteria andLinkNotIn(List<String> values) {
            addCriterion("userworksshopping.Link not in", values, "link");
            return (Criteria) this;
        }

        public Criteria andLinkBetween(String value1, String value2) {
            addCriterion("userworksshopping.Link between", value1, value2, "link");
            return (Criteria) this;
        }

        public Criteria andLinkNotBetween(String value1, String value2) {
            addCriterion("userworksshopping.Link not between", value1, value2, "link");
            return (Criteria) this;
        }

        public Criteria andLinkPriceIsNull() {
            addCriterion("userworksshopping.LinkPrice is null");
            return (Criteria) this;
        }

        public Criteria andLinkPriceIsNotNull() {
            addCriterion("userworksshopping.LinkPrice is not null");
            return (Criteria) this;
        }

        public Criteria andLinkPriceEqualTo(BigDecimal value) {
            addCriterion("userworksshopping.LinkPrice =", value, "linkPrice");
            return (Criteria) this;
        }

        public Criteria andLinkPriceEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.LinkPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLinkPriceNotEqualTo(BigDecimal value) {
            addCriterion("userworksshopping.LinkPrice <>", value, "linkPrice");
            return (Criteria) this;
        }

        public Criteria andLinkPriceNotEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.LinkPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLinkPriceGreaterThan(BigDecimal value) {
            addCriterion("userworksshopping.LinkPrice >", value, "linkPrice");
            return (Criteria) this;
        }

        public Criteria andLinkPriceGreaterThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.LinkPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLinkPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("userworksshopping.LinkPrice >=", value, "linkPrice");
            return (Criteria) this;
        }

        public Criteria andLinkPriceGreaterThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.LinkPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLinkPriceLessThan(BigDecimal value) {
            addCriterion("userworksshopping.LinkPrice <", value, "linkPrice");
            return (Criteria) this;
        }

        public Criteria andLinkPriceLessThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.LinkPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLinkPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("userworksshopping.LinkPrice <=", value, "linkPrice");
            return (Criteria) this;
        }

        public Criteria andLinkPriceLessThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.LinkPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLinkPriceIn(List<BigDecimal> values) {
            addCriterion("userworksshopping.LinkPrice in", values, "linkPrice");
            return (Criteria) this;
        }

        public Criteria andLinkPriceNotIn(List<BigDecimal> values) {
            addCriterion("userworksshopping.LinkPrice not in", values, "linkPrice");
            return (Criteria) this;
        }

        public Criteria andLinkPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("userworksshopping.LinkPrice between", value1, value2, "linkPrice");
            return (Criteria) this;
        }

        public Criteria andLinkPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("userworksshopping.LinkPrice not between", value1, value2, "linkPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsIdIsNull() {
            addCriterion("userworksshopping.GoodsId is null");
            return (Criteria) this;
        }

        public Criteria andGoodsIdIsNotNull() {
            addCriterion("userworksshopping.GoodsId is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsIdEqualTo(Integer value) {
            addCriterion("userworksshopping.GoodsId =", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.GoodsId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotEqualTo(Integer value) {
            addCriterion("userworksshopping.GoodsId <>", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.GoodsId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThan(Integer value) {
            addCriterion("userworksshopping.GoodsId >", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.GoodsId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("userworksshopping.GoodsId >=", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.GoodsId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThan(Integer value) {
            addCriterion("userworksshopping.GoodsId <", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.GoodsId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThanOrEqualTo(Integer value) {
            addCriterion("userworksshopping.GoodsId <=", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.GoodsId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdIn(List<Integer> values) {
            addCriterion("userworksshopping.GoodsId in", values, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotIn(List<Integer> values) {
            addCriterion("userworksshopping.GoodsId not in", values, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdBetween(Integer value1, Integer value2) {
            addCriterion("userworksshopping.GoodsId between", value1, value2, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("userworksshopping.GoodsId not between", value1, value2, "goodsId");
            return (Criteria) this;
        }

        public Criteria andPackagedIdIsNull() {
            addCriterion("userworksshopping.PackagedId is null");
            return (Criteria) this;
        }

        public Criteria andPackagedIdIsNotNull() {
            addCriterion("userworksshopping.PackagedId is not null");
            return (Criteria) this;
        }

        public Criteria andPackagedIdEqualTo(Integer value) {
            addCriterion("userworksshopping.PackagedId =", value, "packagedId");
            return (Criteria) this;
        }

        public Criteria andPackagedIdEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.PackagedId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPackagedIdNotEqualTo(Integer value) {
            addCriterion("userworksshopping.PackagedId <>", value, "packagedId");
            return (Criteria) this;
        }

        public Criteria andPackagedIdNotEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.PackagedId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPackagedIdGreaterThan(Integer value) {
            addCriterion("userworksshopping.PackagedId >", value, "packagedId");
            return (Criteria) this;
        }

        public Criteria andPackagedIdGreaterThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.PackagedId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPackagedIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("userworksshopping.PackagedId >=", value, "packagedId");
            return (Criteria) this;
        }

        public Criteria andPackagedIdGreaterThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.PackagedId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPackagedIdLessThan(Integer value) {
            addCriterion("userworksshopping.PackagedId <", value, "packagedId");
            return (Criteria) this;
        }

        public Criteria andPackagedIdLessThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.PackagedId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPackagedIdLessThanOrEqualTo(Integer value) {
            addCriterion("userworksshopping.PackagedId <=", value, "packagedId");
            return (Criteria) this;
        }

        public Criteria andPackagedIdLessThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.PackagedId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPackagedIdIn(List<Integer> values) {
            addCriterion("userworksshopping.PackagedId in", values, "packagedId");
            return (Criteria) this;
        }

        public Criteria andPackagedIdNotIn(List<Integer> values) {
            addCriterion("userworksshopping.PackagedId not in", values, "packagedId");
            return (Criteria) this;
        }

        public Criteria andPackagedIdBetween(Integer value1, Integer value2) {
            addCriterion("userworksshopping.PackagedId between", value1, value2, "packagedId");
            return (Criteria) this;
        }

        public Criteria andPackagedIdNotBetween(Integer value1, Integer value2) {
            addCriterion("userworksshopping.PackagedId not between", value1, value2, "packagedId");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("userworksshopping.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("userworksshopping.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("userworksshopping.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("userworksshopping.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("userworksshopping.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("userworksshopping.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("userworksshopping.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("userworksshopping.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("userworksshopping.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("userworksshopping.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("userworksshopping.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("userworksshopping.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("userworksshopping.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("userworksshopping.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("userworksshopping.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("userworksshopping.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("userworksshopping.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("userworksshopping.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("userworksshopping.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("userworksshopping.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("userworksshopping.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("userworksshopping.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("userworksshopping.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("userworksshopping.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("userworksshopping.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("userworksshopping.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("userworksshopping.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("userworksshopping.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("userworksshopping.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("userworksshopping.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("userworksshopping.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("userworksshopping.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("userworksshopping.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("userworksshopping.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("userworksshopping.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("userworksshopping.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("userworksshopping.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("userworksshopping.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("userworksshopping.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("userworksshopping.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("userworksshopping.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("userworksshopping.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("userworksshopping.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("userworksshopping.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("userworksshopping.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("userworksshopping.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("userworksshopping.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("userworksshopping.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("userworksshopping.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("userworksshopping.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("userworksshopping.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("userworksshopping.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("userworksshopping.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("userworksshopping.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("userworksshopping.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("userworksshopping.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("userworksshopping.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("userworksshopping.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("userworksshopping.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("userworksshopping.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(UserWorksShopping.Column column) {
            addCriterion(new StringBuilder("userworksshopping.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("userworksshopping.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("userworksshopping.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("userworksshopping.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("userworksshopping.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private UserWorksShoppingExample example;

        protected Criteria(UserWorksShoppingExample example) {
            super();
            this.example = example;
        }

        public UserWorksShoppingExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(UserWorksShopping.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(UserWorksShopping.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.ying.space.entity.UserWorksShoppingExample example);
    }
}